/*
 *
 * ProductChannelGoodsPriceExample.java
 * @author 18304
 * @date 2020-11-24 20:24:02
 */
package com.steel.yfmall.cloud.assistant.po.goods;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class ProductChannelGoodsPriceExample {
    /**
     * product_channel_goods_price
     */
    protected String orderByClause;

    /**
     * product_channel_goods_price
     */
    protected boolean distinct;

    /**
     * product_channel_goods_price
     */
    protected List<Criteria> oredCriteria;

    private Integer limit;

    private Integer offset;

    private String groupByClause;

    private String selectFields;

    /**
     * 构造查询条件:product_channel_goods_price
     * @Title: ProductChannelGoodsPriceExample
     * @Description: ( )
     * @return 返回类型 null
     * @date 2020-11-24 20:24:02
     */
    public ProductChannelGoodsPriceExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    /**
     * 设置排序字段:product_channel_goods_price
     * @Title: setOrderByClause
     * @Description: ( 设置排序字段 )
     * @param 参数说明 类型:String	名称:orderByClause 排序字段
     * @return 返回类型 null
     * @date 2020-11-24 20:24:02
     */
    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    /**
     * 获取排序字段:product_channel_goods_price
     * @Title: getOrderByClause
     * @Description: ( 获取排序字段 )
     * @return 返回类型 java.lang.String
     * @date 2020-11-24 20:24:02
     */
    public String getOrderByClause() {
        return orderByClause;
    }

    /**
     * 设置过滤重复数据:product_channel_goods_price
     * @Title: setDistinct
     * @Description: ( 设置过滤重复数据 )
     * @param 参数说明 类型:boolean	名称:distinct 是否过滤重复数据
     * @return 返回类型 null
     * @date 2020-11-24 20:24:02
     */
    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    /**
     * 是否过滤重复数据:product_channel_goods_price
     * @Title: isDistinct
     * @Description: ( 是否过滤重复数据 )
     * @return 返回类型 boolean
     * @date 2020-11-24 20:24:02
     */
    public boolean isDistinct() {
        return distinct;
    }

    /**
     * 获取当前的查询条件实例:product_channel_goods_price
     * @Title: getOredCriteria
     * @Description: ( 获取当前的查询条件实例 )
     * @return 返回类型 java.util.List<Criteria>
     * @date 2020-11-24 20:24:02
     */
    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    /**
     *:product_channel_goods_price
     * @Title: or
     * @Description: ( )
     *
     * @param 参数说明 类型:Criteria	名称:criteria 过滤条件实例
     * @return 返回类型 null
     * @date 2020-11-24 20:24:02
     */
    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    /**
     *:product_channel_goods_price
     * @Title: or
     * @Description: ( )
     *
     * @return 返回类型 Criteria
     * @date 2020-11-24 20:24:02
     */
    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    /**
     * 创建一个查询条件:product_channel_goods_price
     * @Title: createCriteria
     * @Description: ( 创建一个查询条件 )
     * @return 返回类型 Criteria
     * @date 2020-11-24 20:24:02
     */
    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    /**
     * 内部构建查询条件对象:product_channel_goods_price
     * @Title: createCriteriaInternal
     * @Description: ( 内部构建查询条件对象 )
     * @return 返回类型 Criteria
     * @date 2020-11-24 20:24:02
     */
    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    /**
     * 清除查询条件:product_channel_goods_price
     * @Title: clear
     * @Description: ( 清除查询条件 )
     * @return 返回类型 null
     * @date 2020-11-24 20:24:02
     */
    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    public void limit(Integer offset, Integer limit) {
        this.offset = offset;
        this.limit = limit;
    }

    public Integer getLimit() {
        return limit;
    }

    public void setOffset(Integer offset) {
        this.offset = offset;
    }

    public Integer getOffset() {
        return offset;
    }

    public void setGroupByClause(String groupByClause) {
        this.groupByClause = groupByClause;
    }

    public String getGroupByClause() {
        return groupByClause;
    }

    public void setSelectFields(String selectFields) {
        this.selectFields = selectFields;
    }

    public String getSelectFields() {
        return selectFields;
    }

    /**
     * @title product_channel_goods_price表的实体类
     * @description product_channel_goods_price
     * @version 1.0
     * @author 18304
     * @date 2020-11-24 20:24:02
     */
    protected abstract static class GeneratedCriteria implements java.io.Serializable {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andSellerCodeIsNull() {
            addCriterion("seller_code is null");
            return (Criteria) this;
        }

        public Criteria andSellerCodeIsNotNull() {
            addCriterion("seller_code is not null");
            return (Criteria) this;
        }

        public Criteria andSellerCodeEqualTo(String value) {
            addCriterion("seller_code =", value, "sellerCode");
            return (Criteria) this;
        }

        public Criteria andSellerCodeNotEqualTo(String value) {
            addCriterion("seller_code <>", value, "sellerCode");
            return (Criteria) this;
        }

        public Criteria andSellerCodeGreaterThan(String value) {
            addCriterion("seller_code >", value, "sellerCode");
            return (Criteria) this;
        }

        public Criteria andSellerCodeGreaterThanOrEqualTo(String value) {
            addCriterion("seller_code >=", value, "sellerCode");
            return (Criteria) this;
        }

        public Criteria andSellerCodeLessThan(String value) {
            addCriterion("seller_code <", value, "sellerCode");
            return (Criteria) this;
        }

        public Criteria andSellerCodeLessThanOrEqualTo(String value) {
            addCriterion("seller_code <=", value, "sellerCode");
            return (Criteria) this;
        }

        public Criteria andSellerCodeLike(String value) {
            addCriterion("seller_code like", value, "sellerCode");
            return (Criteria) this;
        }

        public Criteria andSellerCodeNotLike(String value) {
            addCriterion("seller_code not like", value, "sellerCode");
            return (Criteria) this;
        }

        public Criteria andSellerCodeIn(List<String> values) {
            addCriterion("seller_code in", values, "sellerCode");
            return (Criteria) this;
        }

        public Criteria andSellerCodeNotIn(List<String> values) {
            addCriterion("seller_code not in", values, "sellerCode");
            return (Criteria) this;
        }

        public Criteria andSellerCodeBetween(String value1, String value2) {
            addCriterion("seller_code between", value1, value2, "sellerCode");
            return (Criteria) this;
        }

        public Criteria andSellerCodeNotBetween(String value1, String value2) {
            addCriterion("seller_code not between", value1, value2, "sellerCode");
            return (Criteria) this;
        }

        public Criteria andSiteCodeIsNull() {
            addCriterion("site_code is null");
            return (Criteria) this;
        }

        public Criteria andSiteCodeIsNotNull() {
            addCriterion("site_code is not null");
            return (Criteria) this;
        }

        public Criteria andSiteCodeEqualTo(String value) {
            addCriterion("site_code =", value, "siteCode");
            return (Criteria) this;
        }

        public Criteria andSiteCodeNotEqualTo(String value) {
            addCriterion("site_code <>", value, "siteCode");
            return (Criteria) this;
        }

        public Criteria andSiteCodeGreaterThan(String value) {
            addCriterion("site_code >", value, "siteCode");
            return (Criteria) this;
        }

        public Criteria andSiteCodeGreaterThanOrEqualTo(String value) {
            addCriterion("site_code >=", value, "siteCode");
            return (Criteria) this;
        }

        public Criteria andSiteCodeLessThan(String value) {
            addCriterion("site_code <", value, "siteCode");
            return (Criteria) this;
        }

        public Criteria andSiteCodeLessThanOrEqualTo(String value) {
            addCriterion("site_code <=", value, "siteCode");
            return (Criteria) this;
        }

        public Criteria andSiteCodeLike(String value) {
            addCriterion("site_code like", value, "siteCode");
            return (Criteria) this;
        }

        public Criteria andSiteCodeNotLike(String value) {
            addCriterion("site_code not like", value, "siteCode");
            return (Criteria) this;
        }

        public Criteria andSiteCodeIn(List<String> values) {
            addCriterion("site_code in", values, "siteCode");
            return (Criteria) this;
        }

        public Criteria andSiteCodeNotIn(List<String> values) {
            addCriterion("site_code not in", values, "siteCode");
            return (Criteria) this;
        }

        public Criteria andSiteCodeBetween(String value1, String value2) {
            addCriterion("site_code between", value1, value2, "siteCode");
            return (Criteria) this;
        }

        public Criteria andSiteCodeNotBetween(String value1, String value2) {
            addCriterion("site_code not between", value1, value2, "siteCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeIsNull() {
            addCriterion("channel_code is null");
            return (Criteria) this;
        }

        public Criteria andChannelCodeIsNotNull() {
            addCriterion("channel_code is not null");
            return (Criteria) this;
        }

        public Criteria andChannelCodeEqualTo(String value) {
            addCriterion("channel_code =", value, "channelCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeNotEqualTo(String value) {
            addCriterion("channel_code <>", value, "channelCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeGreaterThan(String value) {
            addCriterion("channel_code >", value, "channelCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeGreaterThanOrEqualTo(String value) {
            addCriterion("channel_code >=", value, "channelCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeLessThan(String value) {
            addCriterion("channel_code <", value, "channelCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeLessThanOrEqualTo(String value) {
            addCriterion("channel_code <=", value, "channelCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeLike(String value) {
            addCriterion("channel_code like", value, "channelCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeNotLike(String value) {
            addCriterion("channel_code not like", value, "channelCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeIn(List<String> values) {
            addCriterion("channel_code in", values, "channelCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeNotIn(List<String> values) {
            addCriterion("channel_code not in", values, "channelCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeBetween(String value1, String value2) {
            addCriterion("channel_code between", value1, value2, "channelCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeNotBetween(String value1, String value2) {
            addCriterion("channel_code not between", value1, value2, "channelCode");
            return (Criteria) this;
        }

        public Criteria andProductSysCodeIsNull() {
            addCriterion("product_sys_code is null");
            return (Criteria) this;
        }

        public Criteria andProductSysCodeIsNotNull() {
            addCriterion("product_sys_code is not null");
            return (Criteria) this;
        }

        public Criteria andProductSysCodeEqualTo(String value) {
            addCriterion("product_sys_code =", value, "productSysCode");
            return (Criteria) this;
        }

        public Criteria andProductSysCodeNotEqualTo(String value) {
            addCriterion("product_sys_code <>", value, "productSysCode");
            return (Criteria) this;
        }

        public Criteria andProductSysCodeGreaterThan(String value) {
            addCriterion("product_sys_code >", value, "productSysCode");
            return (Criteria) this;
        }

        public Criteria andProductSysCodeGreaterThanOrEqualTo(String value) {
            addCriterion("product_sys_code >=", value, "productSysCode");
            return (Criteria) this;
        }

        public Criteria andProductSysCodeLessThan(String value) {
            addCriterion("product_sys_code <", value, "productSysCode");
            return (Criteria) this;
        }

        public Criteria andProductSysCodeLessThanOrEqualTo(String value) {
            addCriterion("product_sys_code <=", value, "productSysCode");
            return (Criteria) this;
        }

        public Criteria andProductSysCodeLike(String value) {
            addCriterion("product_sys_code like", value, "productSysCode");
            return (Criteria) this;
        }

        public Criteria andProductSysCodeNotLike(String value) {
            addCriterion("product_sys_code not like", value, "productSysCode");
            return (Criteria) this;
        }

        public Criteria andProductSysCodeIn(List<String> values) {
            addCriterion("product_sys_code in", values, "productSysCode");
            return (Criteria) this;
        }

        public Criteria andProductSysCodeNotIn(List<String> values) {
            addCriterion("product_sys_code not in", values, "productSysCode");
            return (Criteria) this;
        }

        public Criteria andProductSysCodeBetween(String value1, String value2) {
            addCriterion("product_sys_code between", value1, value2, "productSysCode");
            return (Criteria) this;
        }

        public Criteria andProductSysCodeNotBetween(String value1, String value2) {
            addCriterion("product_sys_code not between", value1, value2, "productSysCode");
            return (Criteria) this;
        }

        public Criteria andBarcodeSysCodeIsNull() {
            addCriterion("barcode_sys_code is null");
            return (Criteria) this;
        }

        public Criteria andBarcodeSysCodeIsNotNull() {
            addCriterion("barcode_sys_code is not null");
            return (Criteria) this;
        }

        public Criteria andBarcodeSysCodeEqualTo(String value) {
            addCriterion("barcode_sys_code =", value, "barcodeSysCode");
            return (Criteria) this;
        }

        public Criteria andBarcodeSysCodeNotEqualTo(String value) {
            addCriterion("barcode_sys_code <>", value, "barcodeSysCode");
            return (Criteria) this;
        }

        public Criteria andBarcodeSysCodeGreaterThan(String value) {
            addCriterion("barcode_sys_code >", value, "barcodeSysCode");
            return (Criteria) this;
        }

        public Criteria andBarcodeSysCodeGreaterThanOrEqualTo(String value) {
            addCriterion("barcode_sys_code >=", value, "barcodeSysCode");
            return (Criteria) this;
        }

        public Criteria andBarcodeSysCodeLessThan(String value) {
            addCriterion("barcode_sys_code <", value, "barcodeSysCode");
            return (Criteria) this;
        }

        public Criteria andBarcodeSysCodeLessThanOrEqualTo(String value) {
            addCriterion("barcode_sys_code <=", value, "barcodeSysCode");
            return (Criteria) this;
        }

        public Criteria andBarcodeSysCodeLike(String value) {
            addCriterion("barcode_sys_code like", value, "barcodeSysCode");
            return (Criteria) this;
        }

        public Criteria andBarcodeSysCodeNotLike(String value) {
            addCriterion("barcode_sys_code not like", value, "barcodeSysCode");
            return (Criteria) this;
        }

        public Criteria andBarcodeSysCodeIn(List<String> values) {
            addCriterion("barcode_sys_code in", values, "barcodeSysCode");
            return (Criteria) this;
        }

        public Criteria andBarcodeSysCodeNotIn(List<String> values) {
            addCriterion("barcode_sys_code not in", values, "barcodeSysCode");
            return (Criteria) this;
        }

        public Criteria andBarcodeSysCodeBetween(String value1, String value2) {
            addCriterion("barcode_sys_code between", value1, value2, "barcodeSysCode");
            return (Criteria) this;
        }

        public Criteria andBarcodeSysCodeNotBetween(String value1, String value2) {
            addCriterion("barcode_sys_code not between", value1, value2, "barcodeSysCode");
            return (Criteria) this;
        }

        public Criteria andSaleAttr1ValueCodeIsNull() {
            addCriterion("sale_attr1_value_code is null");
            return (Criteria) this;
        }

        public Criteria andSaleAttr1ValueCodeIsNotNull() {
            addCriterion("sale_attr1_value_code is not null");
            return (Criteria) this;
        }

        public Criteria andSaleAttr1ValueCodeEqualTo(String value) {
            addCriterion("sale_attr1_value_code =", value, "saleAttr1ValueCode");
            return (Criteria) this;
        }

        public Criteria andSaleAttr1ValueCodeNotEqualTo(String value) {
            addCriterion("sale_attr1_value_code <>", value, "saleAttr1ValueCode");
            return (Criteria) this;
        }

        public Criteria andSaleAttr1ValueCodeGreaterThan(String value) {
            addCriterion("sale_attr1_value_code >", value, "saleAttr1ValueCode");
            return (Criteria) this;
        }

        public Criteria andSaleAttr1ValueCodeGreaterThanOrEqualTo(String value) {
            addCriterion("sale_attr1_value_code >=", value, "saleAttr1ValueCode");
            return (Criteria) this;
        }

        public Criteria andSaleAttr1ValueCodeLessThan(String value) {
            addCriterion("sale_attr1_value_code <", value, "saleAttr1ValueCode");
            return (Criteria) this;
        }

        public Criteria andSaleAttr1ValueCodeLessThanOrEqualTo(String value) {
            addCriterion("sale_attr1_value_code <=", value, "saleAttr1ValueCode");
            return (Criteria) this;
        }

        public Criteria andSaleAttr1ValueCodeLike(String value) {
            addCriterion("sale_attr1_value_code like", value, "saleAttr1ValueCode");
            return (Criteria) this;
        }

        public Criteria andSaleAttr1ValueCodeNotLike(String value) {
            addCriterion("sale_attr1_value_code not like", value, "saleAttr1ValueCode");
            return (Criteria) this;
        }

        public Criteria andSaleAttr1ValueCodeIn(List<String> values) {
            addCriterion("sale_attr1_value_code in", values, "saleAttr1ValueCode");
            return (Criteria) this;
        }

        public Criteria andSaleAttr1ValueCodeNotIn(List<String> values) {
            addCriterion("sale_attr1_value_code not in", values, "saleAttr1ValueCode");
            return (Criteria) this;
        }

        public Criteria andSaleAttr1ValueCodeBetween(String value1, String value2) {
            addCriterion("sale_attr1_value_code between", value1, value2, "saleAttr1ValueCode");
            return (Criteria) this;
        }

        public Criteria andSaleAttr1ValueCodeNotBetween(String value1, String value2) {
            addCriterion("sale_attr1_value_code not between", value1, value2, "saleAttr1ValueCode");
            return (Criteria) this;
        }

        public Criteria andSaleAttr2ValueCodeIsNull() {
            addCriterion("sale_attr2_value_code is null");
            return (Criteria) this;
        }

        public Criteria andSaleAttr2ValueCodeIsNotNull() {
            addCriterion("sale_attr2_value_code is not null");
            return (Criteria) this;
        }

        public Criteria andSaleAttr2ValueCodeEqualTo(String value) {
            addCriterion("sale_attr2_value_code =", value, "saleAttr2ValueCode");
            return (Criteria) this;
        }

        public Criteria andSaleAttr2ValueCodeNotEqualTo(String value) {
            addCriterion("sale_attr2_value_code <>", value, "saleAttr2ValueCode");
            return (Criteria) this;
        }

        public Criteria andSaleAttr2ValueCodeGreaterThan(String value) {
            addCriterion("sale_attr2_value_code >", value, "saleAttr2ValueCode");
            return (Criteria) this;
        }

        public Criteria andSaleAttr2ValueCodeGreaterThanOrEqualTo(String value) {
            addCriterion("sale_attr2_value_code >=", value, "saleAttr2ValueCode");
            return (Criteria) this;
        }

        public Criteria andSaleAttr2ValueCodeLessThan(String value) {
            addCriterion("sale_attr2_value_code <", value, "saleAttr2ValueCode");
            return (Criteria) this;
        }

        public Criteria andSaleAttr2ValueCodeLessThanOrEqualTo(String value) {
            addCriterion("sale_attr2_value_code <=", value, "saleAttr2ValueCode");
            return (Criteria) this;
        }

        public Criteria andSaleAttr2ValueCodeLike(String value) {
            addCriterion("sale_attr2_value_code like", value, "saleAttr2ValueCode");
            return (Criteria) this;
        }

        public Criteria andSaleAttr2ValueCodeNotLike(String value) {
            addCriterion("sale_attr2_value_code not like", value, "saleAttr2ValueCode");
            return (Criteria) this;
        }

        public Criteria andSaleAttr2ValueCodeIn(List<String> values) {
            addCriterion("sale_attr2_value_code in", values, "saleAttr2ValueCode");
            return (Criteria) this;
        }

        public Criteria andSaleAttr2ValueCodeNotIn(List<String> values) {
            addCriterion("sale_attr2_value_code not in", values, "saleAttr2ValueCode");
            return (Criteria) this;
        }

        public Criteria andSaleAttr2ValueCodeBetween(String value1, String value2) {
            addCriterion("sale_attr2_value_code between", value1, value2, "saleAttr2ValueCode");
            return (Criteria) this;
        }

        public Criteria andSaleAttr2ValueCodeNotBetween(String value1, String value2) {
            addCriterion("sale_attr2_value_code not between", value1, value2, "saleAttr2ValueCode");
            return (Criteria) this;
        }

        public Criteria andSpecPriceIsNull() {
            addCriterion("spec_price is null");
            return (Criteria) this;
        }

        public Criteria andSpecPriceIsNotNull() {
            addCriterion("spec_price is not null");
            return (Criteria) this;
        }

        public Criteria andSpecPriceEqualTo(BigDecimal value) {
            addCriterion("spec_price =", value, "specPrice");
            return (Criteria) this;
        }

        public Criteria andSpecPriceNotEqualTo(BigDecimal value) {
            addCriterion("spec_price <>", value, "specPrice");
            return (Criteria) this;
        }

        public Criteria andSpecPriceGreaterThan(BigDecimal value) {
            addCriterion("spec_price >", value, "specPrice");
            return (Criteria) this;
        }

        public Criteria andSpecPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("spec_price >=", value, "specPrice");
            return (Criteria) this;
        }

        public Criteria andSpecPriceLessThan(BigDecimal value) {
            addCriterion("spec_price <", value, "specPrice");
            return (Criteria) this;
        }

        public Criteria andSpecPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("spec_price <=", value, "specPrice");
            return (Criteria) this;
        }

        public Criteria andSpecPriceIn(List<BigDecimal> values) {
            addCriterion("spec_price in", values, "specPrice");
            return (Criteria) this;
        }

        public Criteria andSpecPriceNotIn(List<BigDecimal> values) {
            addCriterion("spec_price not in", values, "specPrice");
            return (Criteria) this;
        }

        public Criteria andSpecPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("spec_price between", value1, value2, "specPrice");
            return (Criteria) this;
        }

        public Criteria andSpecPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("spec_price not between", value1, value2, "specPrice");
            return (Criteria) this;
        }

        public Criteria andSpecCoinIsNull() {
            addCriterion("spec_coin is null");
            return (Criteria) this;
        }

        public Criteria andSpecCoinIsNotNull() {
            addCriterion("spec_coin is not null");
            return (Criteria) this;
        }

        public Criteria andSpecCoinEqualTo(BigDecimal value) {
            addCriterion("spec_coin =", value, "specCoin");
            return (Criteria) this;
        }

        public Criteria andSpecCoinNotEqualTo(BigDecimal value) {
            addCriterion("spec_coin <>", value, "specCoin");
            return (Criteria) this;
        }

        public Criteria andSpecCoinGreaterThan(BigDecimal value) {
            addCriterion("spec_coin >", value, "specCoin");
            return (Criteria) this;
        }

        public Criteria andSpecCoinGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("spec_coin >=", value, "specCoin");
            return (Criteria) this;
        }

        public Criteria andSpecCoinLessThan(BigDecimal value) {
            addCriterion("spec_coin <", value, "specCoin");
            return (Criteria) this;
        }

        public Criteria andSpecCoinLessThanOrEqualTo(BigDecimal value) {
            addCriterion("spec_coin <=", value, "specCoin");
            return (Criteria) this;
        }

        public Criteria andSpecCoinIn(List<BigDecimal> values) {
            addCriterion("spec_coin in", values, "specCoin");
            return (Criteria) this;
        }

        public Criteria andSpecCoinNotIn(List<BigDecimal> values) {
            addCriterion("spec_coin not in", values, "specCoin");
            return (Criteria) this;
        }

        public Criteria andSpecCoinBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("spec_coin between", value1, value2, "specCoin");
            return (Criteria) this;
        }

        public Criteria andSpecCoinNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("spec_coin not between", value1, value2, "specCoin");
            return (Criteria) this;
        }

        public Criteria andMemberPriceIsNull() {
            addCriterion("member_price is null");
            return (Criteria) this;
        }

        public Criteria andMemberPriceIsNotNull() {
            addCriterion("member_price is not null");
            return (Criteria) this;
        }

        public Criteria andMemberPriceEqualTo(BigDecimal value) {
            addCriterion("member_price =", value, "memberPrice");
            return (Criteria) this;
        }

        public Criteria andMemberPriceNotEqualTo(BigDecimal value) {
            addCriterion("member_price <>", value, "memberPrice");
            return (Criteria) this;
        }

        public Criteria andMemberPriceGreaterThan(BigDecimal value) {
            addCriterion("member_price >", value, "memberPrice");
            return (Criteria) this;
        }

        public Criteria andMemberPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("member_price >=", value, "memberPrice");
            return (Criteria) this;
        }

        public Criteria andMemberPriceLessThan(BigDecimal value) {
            addCriterion("member_price <", value, "memberPrice");
            return (Criteria) this;
        }

        public Criteria andMemberPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("member_price <=", value, "memberPrice");
            return (Criteria) this;
        }

        public Criteria andMemberPriceIn(List<BigDecimal> values) {
            addCriterion("member_price in", values, "memberPrice");
            return (Criteria) this;
        }

        public Criteria andMemberPriceNotIn(List<BigDecimal> values) {
            addCriterion("member_price not in", values, "memberPrice");
            return (Criteria) this;
        }

        public Criteria andMemberPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("member_price between", value1, value2, "memberPrice");
            return (Criteria) this;
        }

        public Criteria andMemberPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("member_price not between", value1, value2, "memberPrice");
            return (Criteria) this;
        }

        public Criteria andLevelPriceMapIsNull() {
            addCriterion("level_price_map is null");
            return (Criteria) this;
        }

        public Criteria andLevelPriceMapIsNotNull() {
            addCriterion("level_price_map is not null");
            return (Criteria) this;
        }

        public Criteria andLevelPriceMapEqualTo(String value) {
            addCriterion("level_price_map =", value, "levelPriceMap");
            return (Criteria) this;
        }

        public Criteria andLevelPriceMapNotEqualTo(String value) {
            addCriterion("level_price_map <>", value, "levelPriceMap");
            return (Criteria) this;
        }

        public Criteria andLevelPriceMapGreaterThan(String value) {
            addCriterion("level_price_map >", value, "levelPriceMap");
            return (Criteria) this;
        }

        public Criteria andLevelPriceMapGreaterThanOrEqualTo(String value) {
            addCriterion("level_price_map >=", value, "levelPriceMap");
            return (Criteria) this;
        }

        public Criteria andLevelPriceMapLessThan(String value) {
            addCriterion("level_price_map <", value, "levelPriceMap");
            return (Criteria) this;
        }

        public Criteria andLevelPriceMapLessThanOrEqualTo(String value) {
            addCriterion("level_price_map <=", value, "levelPriceMap");
            return (Criteria) this;
        }

        public Criteria andLevelPriceMapLike(String value) {
            addCriterion("level_price_map like", value, "levelPriceMap");
            return (Criteria) this;
        }

        public Criteria andLevelPriceMapNotLike(String value) {
            addCriterion("level_price_map not like", value, "levelPriceMap");
            return (Criteria) this;
        }

        public Criteria andLevelPriceMapIn(List<String> values) {
            addCriterion("level_price_map in", values, "levelPriceMap");
            return (Criteria) this;
        }

        public Criteria andLevelPriceMapNotIn(List<String> values) {
            addCriterion("level_price_map not in", values, "levelPriceMap");
            return (Criteria) this;
        }

        public Criteria andLevelPriceMapBetween(String value1, String value2) {
            addCriterion("level_price_map between", value1, value2, "levelPriceMap");
            return (Criteria) this;
        }

        public Criteria andLevelPriceMapNotBetween(String value1, String value2) {
            addCriterion("level_price_map not between", value1, value2, "levelPriceMap");
            return (Criteria) this;
        }

        public Criteria andPreSalePriceIsNull() {
            addCriterion("pre_sale_price is null");
            return (Criteria) this;
        }

        public Criteria andPreSalePriceIsNotNull() {
            addCriterion("pre_sale_price is not null");
            return (Criteria) this;
        }

        public Criteria andPreSalePriceEqualTo(BigDecimal value) {
            addCriterion("pre_sale_price =", value, "preSalePrice");
            return (Criteria) this;
        }

        public Criteria andPreSalePriceNotEqualTo(BigDecimal value) {
            addCriterion("pre_sale_price <>", value, "preSalePrice");
            return (Criteria) this;
        }

        public Criteria andPreSalePriceGreaterThan(BigDecimal value) {
            addCriterion("pre_sale_price >", value, "preSalePrice");
            return (Criteria) this;
        }

        public Criteria andPreSalePriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("pre_sale_price >=", value, "preSalePrice");
            return (Criteria) this;
        }

        public Criteria andPreSalePriceLessThan(BigDecimal value) {
            addCriterion("pre_sale_price <", value, "preSalePrice");
            return (Criteria) this;
        }

        public Criteria andPreSalePriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("pre_sale_price <=", value, "preSalePrice");
            return (Criteria) this;
        }

        public Criteria andPreSalePriceIn(List<BigDecimal> values) {
            addCriterion("pre_sale_price in", values, "preSalePrice");
            return (Criteria) this;
        }

        public Criteria andPreSalePriceNotIn(List<BigDecimal> values) {
            addCriterion("pre_sale_price not in", values, "preSalePrice");
            return (Criteria) this;
        }

        public Criteria andPreSalePriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("pre_sale_price between", value1, value2, "preSalePrice");
            return (Criteria) this;
        }

        public Criteria andPreSalePriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("pre_sale_price not between", value1, value2, "preSalePrice");
            return (Criteria) this;
        }

        public Criteria andDepositPriceIsNull() {
            addCriterion("deposit_price is null");
            return (Criteria) this;
        }

        public Criteria andDepositPriceIsNotNull() {
            addCriterion("deposit_price is not null");
            return (Criteria) this;
        }

        public Criteria andDepositPriceEqualTo(BigDecimal value) {
            addCriterion("deposit_price =", value, "depositPrice");
            return (Criteria) this;
        }

        public Criteria andDepositPriceNotEqualTo(BigDecimal value) {
            addCriterion("deposit_price <>", value, "depositPrice");
            return (Criteria) this;
        }

        public Criteria andDepositPriceGreaterThan(BigDecimal value) {
            addCriterion("deposit_price >", value, "depositPrice");
            return (Criteria) this;
        }

        public Criteria andDepositPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("deposit_price >=", value, "depositPrice");
            return (Criteria) this;
        }

        public Criteria andDepositPriceLessThan(BigDecimal value) {
            addCriterion("deposit_price <", value, "depositPrice");
            return (Criteria) this;
        }

        public Criteria andDepositPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("deposit_price <=", value, "depositPrice");
            return (Criteria) this;
        }

        public Criteria andDepositPriceIn(List<BigDecimal> values) {
            addCriterion("deposit_price in", values, "depositPrice");
            return (Criteria) this;
        }

        public Criteria andDepositPriceNotIn(List<BigDecimal> values) {
            addCriterion("deposit_price not in", values, "depositPrice");
            return (Criteria) this;
        }

        public Criteria andDepositPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("deposit_price between", value1, value2, "depositPrice");
            return (Criteria) this;
        }

        public Criteria andDepositPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("deposit_price not between", value1, value2, "depositPrice");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("status is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("status is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(Integer value) {
            addCriterion("status =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(Integer value) {
            addCriterion("status <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(Integer value) {
            addCriterion("status >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("status >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(Integer value) {
            addCriterion("status <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(Integer value) {
            addCriterion("status <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<Integer> values) {
            addCriterion("status in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<Integer> values) {
            addCriterion("status not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(Integer value1, Integer value2) {
            addCriterion("status between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("status not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNull() {
            addCriterion("create_user is null");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNotNull() {
            addCriterion("create_user is not null");
            return (Criteria) this;
        }

        public Criteria andCreateUserEqualTo(String value) {
            addCriterion("create_user =", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotEqualTo(String value) {
            addCriterion("create_user <>", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThan(String value) {
            addCriterion("create_user >", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanOrEqualTo(String value) {
            addCriterion("create_user >=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThan(String value) {
            addCriterion("create_user <", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanOrEqualTo(String value) {
            addCriterion("create_user <=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLike(String value) {
            addCriterion("create_user like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotLike(String value) {
            addCriterion("create_user not like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserIn(List<String> values) {
            addCriterion("create_user in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotIn(List<String> values) {
            addCriterion("create_user not in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserBetween(String value1, String value2) {
            addCriterion("create_user between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotBetween(String value1, String value2) {
            addCriterion("create_user not between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("create_time is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("create_time is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("create_time =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("create_time <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("create_time >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("create_time >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("create_time <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("create_time <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("create_time in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("create_time not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("create_time between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("create_time not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNull() {
            addCriterion("update_user is null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNotNull() {
            addCriterion("update_user is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserEqualTo(String value) {
            addCriterion("update_user =", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotEqualTo(String value) {
            addCriterion("update_user <>", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThan(String value) {
            addCriterion("update_user >", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanOrEqualTo(String value) {
            addCriterion("update_user >=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThan(String value) {
            addCriterion("update_user <", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanOrEqualTo(String value) {
            addCriterion("update_user <=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLike(String value) {
            addCriterion("update_user like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotLike(String value) {
            addCriterion("update_user not like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIn(List<String> values) {
            addCriterion("update_user in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotIn(List<String> values) {
            addCriterion("update_user not in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserBetween(String value1, String value2) {
            addCriterion("update_user between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotBetween(String value1, String value2) {
            addCriterion("update_user not between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("update_time is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("update_time is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("update_time =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("update_time <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("update_time >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("update_time >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("update_time <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("update_time <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("update_time in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("update_time not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("update_time between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("update_time not between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andControllerNameIsNull() {
            addCriterion("controller_name is null");
            return (Criteria) this;
        }

        public Criteria andControllerNameIsNotNull() {
            addCriterion("controller_name is not null");
            return (Criteria) this;
        }

        public Criteria andControllerNameEqualTo(String value) {
            addCriterion("controller_name =", value, "controllerName");
            return (Criteria) this;
        }

        public Criteria andControllerNameNotEqualTo(String value) {
            addCriterion("controller_name <>", value, "controllerName");
            return (Criteria) this;
        }

        public Criteria andControllerNameGreaterThan(String value) {
            addCriterion("controller_name >", value, "controllerName");
            return (Criteria) this;
        }

        public Criteria andControllerNameGreaterThanOrEqualTo(String value) {
            addCriterion("controller_name >=", value, "controllerName");
            return (Criteria) this;
        }

        public Criteria andControllerNameLessThan(String value) {
            addCriterion("controller_name <", value, "controllerName");
            return (Criteria) this;
        }

        public Criteria andControllerNameLessThanOrEqualTo(String value) {
            addCriterion("controller_name <=", value, "controllerName");
            return (Criteria) this;
        }

        public Criteria andControllerNameLike(String value) {
            addCriterion("controller_name like", value, "controllerName");
            return (Criteria) this;
        }

        public Criteria andControllerNameNotLike(String value) {
            addCriterion("controller_name not like", value, "controllerName");
            return (Criteria) this;
        }

        public Criteria andControllerNameIn(List<String> values) {
            addCriterion("controller_name in", values, "controllerName");
            return (Criteria) this;
        }

        public Criteria andControllerNameNotIn(List<String> values) {
            addCriterion("controller_name not in", values, "controllerName");
            return (Criteria) this;
        }

        public Criteria andControllerNameBetween(String value1, String value2) {
            addCriterion("controller_name between", value1, value2, "controllerName");
            return (Criteria) this;
        }

        public Criteria andControllerNameNotBetween(String value1, String value2) {
            addCriterion("controller_name not between", value1, value2, "controllerName");
            return (Criteria) this;
        }
    }

    /**
     * product_channel_goods_price
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    /**
     * @title product_channel_goods_price表的实体类
     * @description product_channel_goods_price
     * @version 1.0
     * @author 18304
     * @date 2020-11-24 20:24:02
     */
    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}
